how to get the Last Inserted Id in laravel

115

Get last id in laravel -

$last3 = DB::table('items')->latest('id')->first();

how to get the Last Inserted Id in laravel -

//if you have used save method like this
$data->save();
//use this to get last row id;
$lastRowId = $data->id;

//For other insert methods get last inserted id like below
    
    //Using create() method
    $book = Book::create(['name'=>'Laravel Warrior']);
    $lastId = $book->id;

    //Using insertGetId()
    $id = DB::table('books')->insertGetId( ['name' => 'Laravel warrior'] );   
    $lastId = $id;

    //Using lastInsertId() method
    $lastId = DB::getPdo()->lastInsertId();

Get last id in laravel -

$last = DB::table('items')->latest()->first();

return last inserted id in laravel -

DB::getPdo()->lastInsertId();

Comments

Submit
0 Comments